1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY FIELD(p2c.products_id, )' at line 24

SELECT p2c.products_id, pd.products_name, COALESCE(ac.cities_name, '') AS cities_name, p2c.country_id, ar.regions_name, pd.img_num, pd.img_type, pd.img_path, cd.categories_name, pd.color FROM products_to_categories p2c INNER JOIN products_short_d pd ON p2c.products_id = pd.products_id INNER JOIN categories c ON p2c.categories_id = c.categories_id INNER JOIN categories_description cd ON c.categories_id = cd.categories_id AND cd.language_id = '4' LEFT JOIN a_regions ar ON p2c.region_id = ar.regions_id LEFT JOIN a_cities ac ON p2c.city_id = ac.cities_id WHERE p2c.status_id = '1' AND p2c.products_id IN () ORDER BY FIELD(p2c.products_id, )

[TEP STOP]